This section describes the essential skills and knowledge and their level required for this unit

Required skills

communication skills to

consult effectively with relevant personnel

impart knowledge and ideas through oral written and visual means

initiative and enterprise skills to

apply logic to interpret and analyse spatial tasks

interpret project requirements

literacy skills to

evaluate the purposes and uses of various features of spreadsheets

use a variety of strategies for planning and reviewing own work

numeracy skills to

apply trigonometrical functions when using spreadsheets

collate and present data graphs and related references

solve spatial and surveying computations

planning and organising skills to

plan and prioritise activities to meet contractual requirements

conduct project activity

manage information

proofreading and editing skills to check for accuracy and consistency of information consulting additional resources where required

technology skills to use computers for spreadsheet operations

Required knowledge

advanced functions of spreadsheet software applications

display principles including

colour

composition

font type

legends

media

scale

size

text and line style

database structures including the relationship of spatial features of database

formatting and design of spreadsheets and their impact on the presentation and readability of data

surveying and spatial information services SSIS reference systems

The evidence guide provides advice on assessment and must be read in conjunction with the performance criteria required skills and knowledge the range statement and the Assessment Guidelines for this Training Package

Overview of assessment

This unit of competency could be assessed on its own or in combination with other units relevant to the job function

Critical aspects for assessment and evidence required to demonstrate competency in this unit

A person who demonstrates competency in this unit must be able to provide evidence of

developing spreadsheets using complex mathematical formulas involving trigonometrical functions

developing graphical representation of data contained in spreadsheets

knowledge of spreadsheet software application

Specific resources for assessment

Resource implications for assessment include access to

assessment instruments including personal planner and assessment record book

assignment instructions work plans and schedules policy documents and duty statements

registered training provider of assessment services

relevant GIS data

relevant guidelines regulations and codes of practice

suitable venue and equipment

Access must be provided to appropriate learning and assessment support when required

Where applicable physical resources should include equipment modified for people with disabilities

Context of assessment

Holistic based on the performance criteria evidence guide range statement and required skills and knowledge

Method of assessment

Demonstrated over a period of time and observed by the assessor or assessment team working together to conduct the assessment

Demonstrated competency in a range of situations which may include customerworkplace interruptions and involvement in related activities normally experienced in the workplace

Obtained by observing activities in the field and reviewing induction information If this is not practicable observation in realistic simulated environments may be substituted

Guidance information for assessment

Assessment requires that the clients objectives and industry expectations are met If the clients objectives are narrowly defined or not representative of industry needs it may be necessary to refer to portfolio case studies of a variety of SIS requirements to assess competency

Oral questioning or written assessment and hypothetical situations scenarios may be used to assess underpinning knowledge in assessment situations where the candidate is offered a preference between oral questioning or written assessment questions are to be identical

Supplementary evidence may be obtained from relevant authenticated correspondence from existing supervisors team leaders or specialist training staff

All practical demonstration must adhere to the safety and environmental regulations relevant to each State or Territory

Ergonomic requirements may include:

End users may include:

Clients may include:

Work organisation strategies may include:

Energy and resource conservation techniques may include:

Templates may include:

Spreadsheet design may include:

Functions may include:

Formulas may include:

Graphs may include:

Naming and storing of spreadsheets may include: